package ylsb.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import ylsb.model.*;

public interface HcjieguoMapper {
    Object getPinguiResultCount(@Param("xiangmuid") String mmxiangmuId,
                                @Param("userid") String mmuserId,
                                @Param("result") String mmresult);
    Object getPinzhongResultCount(@Param("xiangmuid") String mmxiangmuId,
                                  @Param("userid") String mmuserId,
                                  @Param("result") String mmresult);
    Object getPinpaiResultCount(@Param("xiangmuid") String mmxiangmuId,
                                  @Param("userid") String mmuserId,
                                  @Param("result") String mmresult);
    Object checkPinpaiResultCountResult(@Param("pinzhong") int ppPinzhong,
                                        @Param("userid") String mmuserId,
                                        @Param("xiangmuid") String mmxiangmuId );

    List<Map<String, Object>> findPinpaiJieguo(@Param("xiangmuid")String ppxiangmuId,
                                               @Param("userid")String ppuserId,
                                               @Param("pinzhongxuhao")String mmPinzhonxuhao,
                                               @Param("pinpai")String mmPinpaixuhao);
    List<Map<String, Object>> findPinguiJieguo(@Param("xiangmuid")String ppxiangmuId,
                                               @Param("userid")String ppuserId,
                                               @Param("detailid")String ppdetailId,
                                               @Param("pinzhongxuhao")String mmPinzhonxuhao,
                                               @Param("pinpai")String mmPinpaixuhao);

    List<Map<String, Object>> findPinzhongResult(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("pinzhongxuhao")String ppPinzhong);

    List<Map<String, Object>> findResultGuochanBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("pinzhongxuhao")String ppPinzhong);

    List<Map<String, Object>> mmPinpaiByPinzhongList(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("pinzhongxuhao")int ppPinzhong);
    List<Map<String, Object>> mmPinpaimuluByPinzhongList(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")int ppPinzhong);

    List<Map<String, Object>> findFengbiResult(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("pinzhongxuhao")String ppPinzhong);

    int countByExample(ShijihaocaijieguoExample example);

    int deleteByExample(ShijihaocaijieguoExample example);

    int deleteByPrimaryKey(String id);

    int insert(Hcjieguo record);

    int insertSelective(Shijihaocaijieguo record);

    List<Hcjieguo> selectByExample(HcjieguoExample example);

    Hcjieguo selectByPrimaryKey(String id);

    int updateByExampleSelective(@Param("record") Shijihaocaijieguo record, @Param("example") ShijihaocaijieguoExample example);

    int updateByExample(@Param("record") Shijihaocaijieguo record, @Param("example") ShijihaocaijieguoExample example);

    int updateByPrimaryKeySelective(Hcjieguo record);

    int updateByPrimaryKey(Shijihaocaijieguo record);

    List<Shijipinzhong> selectDaochuByXiangmuid(@Param("xiangmuid") String xiangmuid, @Param("userid") String userid);

    List<Shijipinzhong> selectHuizongByXiangmuid(@Param("xiangmuid") String xiangmuid);

    int selectpinpaipiaoshuByXiangmuidAndPinzhongxuhaoAndPinpai(@Param("xiangmuid") String xiangmuid,
                                                                @Param("pinzhongxuhao") int pinzhongxuhao,
                                                                @Param("pinpai") String pinpai);
}